﻿<?php
$host="localhost"; // Host name 
$username="root"; // Mysql username  
$password="root123"; // Mysql password 
$db_name="hambaa_tshirts"; // Database name 

mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

// To protect MySQL injection (more detail about MySQL injection)
//$productId = stripslashes($productId);
//$productId = mysql_real_escape_string($productId);


$tshirt_thumb_sql = "select p1.id_product,p1.nm_product,p1.desc_product,p1.price from products p1";

$tshirt_colours_sql="select p2.id_product,p2.colour from products p1 inner join products p2 on p1.id_category=p2.id_category where p1.id_product='1'";

$productId=1;

$result_tshirt_thumb_sql=mysql_query($tshirt_thumb_sql);

$result_tshirt_colours_sql=mysql_query($tshirt_colours_sql);


$row_thumb = mysql_fetch_array($result_tshirt_thumb_sql);
//$row_colours = mysql_fetch_array($result_tshirt_colours_sql);

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Merchandise :: Hambaa.com</title>
<link rel="stylesheet" type="text/css" href="styles/Graphitti_style.css" />

<!--<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js">

</script>-->
<script type="text/javascript" src="jquery.min.js"></script>

<script type="text/javascript" src="javascript/cart.js"></script>

<script src="reelslideshow.js" type="text/javascript"></script>

<script type="text/JavaScript">
$(document).ready(function() {
	$('#gallery li').hover(
		function(){$('span',this).slideToggle('medium');},
		function(){$('span',this).slideToggle('medium');
     });
});
</script>


<style>
		.black_overlay{
			display: none;
			position: fixed;
			top: 0%;
			left: 0%;
			width: 100%;
			height: 100%;
			background-color: black;
			z-index:1001;
			-moz-opacity: 0.8;
			opacity:.50;
			filter: alpha(opacity=80);
		}
		.white_content {
			display: none;
			position: fixed;
			top: 25%;
			left: 25%;
			width: 50%;
			height: 50%;
			padding: 16px;
			border: 16px solid orange;
			background-color: white;
			z-index:1002;
			overflow: auto;
		}
	</style>


<style type="text/css">


/* Tutorial CSS */
#gallery {
margin: 0px; 
width: 100%; 
overflow: hidden;
padding: 0px;
}
#gallery li {
float: left; 
margin: 0 0px 0px 0; 
width: 212px; 
height: 212px; 
position: relative; 
color: #FFFS;

}
#gallery li img {padding: 1px;
background: #ececec; 
border: 1px solid #ccc;
}
#gallery li h3 {
font:  18px ;
color:#FFF;
padding: 0;
margin: 0;

}
#gallery li span {
display: none; 
font-size: 14px; 
position: absolute; 
bottom: 7px; 
left: 7px; 
padding: 5px; 
background-image:url(bg_black_trans.png);
width: 190px; 
line-height: 1.2em;
}
</style>

</head>

<body>


<table id="containertable" cellpadding="0" cellspacing="0" border="0" width="950" align="center" >
<tr>
<td align="right">
	<div id="menulinks">
   
    <a href="index.php" class="active">Home</a>
    <a href="offers.php">Offers</a>
	<a href="about_us.php">About Us</a>
	<a href="contact_us.php">Contact Us</a>
    
    </div>

</td>
</tr>

</table>



<table  border="0" align="center" width="952" height="118" background="images/round_back1.png"  >
<tr >
<td width="121" height="114" align="right" valign="bottom">

<a href="index.php"><img src="images/logopng.png" width="103" height="99" /></a></td>
<td width="819" align="left" valign="top">
<a href="index.php"><img src="images/hambaa_logo_newjpg.jpg" width="308" height="107" /></a>
</td>

</tr>
</table>


<table id="hotitem_cart" border="0" width="950"  align="center" bgcolor="#FFFFFF" >
<tr>
<td width="8"></td>
<td width="356">
Order for your tshirt from our wide range.<br>
What's better, now you can create your own design! 
</td>
<td width="164"><img src="images/hot_items.png" width="164" height="61" /></td>
<td width="55">
        <img src="images/tshirts/ts1.jpg" height="55" width="55" />
</td>
        <td width="55">
        <img src="images/tshirts/ts2.jpg" height="55" width="55" />
        </td>
        <td width="55">
        <img src="images/tshirts/ts3.jpg" height="55" width="55" />
        </td>
         <td width="55">
        <img src="images/tshirts/ts4.jpg" height="55" width="55"  />
        </td>	

<td  align="right" width="150" >

<a href = "javascript:void(0)" class="cartbtn" onclick = "document.getElementById('light').style.display='block';document.getElementById('fade').style.display='block';getShoppingCart()"><table border="0" ><tr><td><img src="images/shopping_cart1.png" width="41" height="41" /></td>
<td>Cart(<span  id="order_count"></span>)</td></tr></table></a>

		<div id="light" class="white_content" >
        <div id="close_button" style="position:fixed;width:inherit;float:right" >
        <a href = "javascript:void(0)" onclick = "document.getElementById('light').style.display='none';document.getElementById('fade').style.display='none'"   ><img src="images/Close-button.png"  /></a></div>
        
 
 			<div id="table_container" style="overflow:auto" >
<!--            this is where the table is created -->
             
            </div>
           
            
 
        
        
        
        </div>

		<div id="fade" class="black_overlay" >
        
        </div>
</td>
</tr>

</table>






<table id="outertable" border="0" width="950" height="269" align="center" bgcolor="#FFFFFF" >
<tr >
<td width="690">


    <table id="innerleft" border="0"  height="269" align="center" bgcolor="#F5F5F5" cellspacing="2" >
    <tr bgcolor="#FF6600">
    	<td><h6><?php echo $row_thumb['desc_product']?></h6></td>
         <?php
      ($row_thumb = mysql_fetch_array($result_tshirt_thumb_sql));
?>
    	<td><h6><?php echo $row_thumb['desc_product']?></h6></td>
    	<td><h6>info about tshirt</h6></td>
    </tr>
    <tr>
        <td>
        	<ul id="gallery">
            <li>
            <a href="details.php?productId=1&colour=0">
			<img  src="images/tshirts/ts1.jpg" height="210" 

width="210" />
			</a>
			<span  style="color:#FFF;   font-size:13px;  font-family:Tahoma, Geneva, sans-serif">
            
            Available in   		Black Red Blue

            <?php
      while($row_colours = mysql_fetch_array($result_tshirt_colours_sql))
	  {?>
        <!--<?php echo $row_colours['colour']; ?>-->
      
	  <?php
	  }
	  ?>
            
            <br>Rs. <?php echo $row_thumb['price']?>/-</span>
	  </li>
      </ul>
      
       

        </td>
        <td> 
        <ul id="gallery">
            <li>
            <a href="details.php?productId=2&colour=2">
			<img  src="images/tshirts/ts2.jpg" height="210" 

width="210" />
			</a>
			<span  style="color:#FFF;   font-size:13px;  font-family:Tahoma, Geneva, sans-serif">This is the caption for the first image</span>
	  </li>
      </ul>
        </td>
        <td>
        <ul id="gallery">
            <li>
            <a href="details.php?productId=3&colour=3">
			<img  src="images/tshirts/ts3.jpg" height="210" 

width="210" />
			</a>
			<span  style="color:#FFF;   font-size:13px;  font-family:Tahoma, Geneva, sans-serif">This is the caption for the first image</span>
	  </li>
      </ul>
        </td>
        
    </tr>
    <tr bgcolor="#FF6600"  >
    	<td><h6>info about tshirt</h6></td>
    	<td><h6>info about tshirt</h6></td>
    	<td><h6>info about tshirt</h6></td>
    </tr>
        <tr>
        <td>
        <ul id="gallery">
            <li>
            <a href="details.php?productId=5&colour=3">
			<img  src="images/tshirts/design 1 type 1.png" height="210" 

width="210" />
			</a>
			<span  style="color:#FFF;   font-size:13px;  font-family:Tahoma, Geneva, sans-serif">This is the caption for the first image</span>
	  </li>
      </ul>
        </td>	
        <td>
        <ul id="gallery">
            <li>
            <a href="details.php?productId=4&colour=0">
			<img  src="images/tshirts/ts4.jpg" height="210" 

width="210" />
			</a>
			<span  style="color:#FFF;   font-size:13px;  font-family:Tahoma, Geneva, sans-serif">This is the caption for the first image</span>
	  </li>
      </ul>
        </td>
        <td>
        <ul id="gallery">
            <li>
            <a href="details.php?productId=6&colour=2">
			<img  src="images/tshirts/ts6.jpg" height="210" 

width="210" />
			</a>
			<span  style="color:#FFF;   font-size:13px;  font-family:Tahoma, Geneva, sans-serif">This is the caption for the first image</span>
	  </li>
      </ul>
        </td>	
    </tr>
    </table>
</td>

<td valign="top">
		<table id="innerright" border="0" cellspacing="2"  width="260" align="right" background="images/tableback3.png">
	<tr><td><h4 >hambaa@you</h4></td></tr>
    
    <tr><td bgcolor="#FF6600"> <h6>&nbsp; Create your own design!</h6> </td></tr>
    
	<tr><td align="center">
    <iframe width="255" height="255" src="Untitled-1.html" frameborder="0" scrolling="no"  />
</iframe></td></tr>

	 <tr align="center" ><td align="center"> 
         <h4>Customize your tshirt yourself</h4>
     </td></tr>
     <tr><td >
     <hr />
     </td></tr>
     
       <tr><td align="center" bgcolor="#FFFFFF" valign="middle">
    <a href = "mywishlist.php?timefilter=all" class="wishbtn" > My Wishlist</a><br><br>
    </td></tr>
    
     <tr><td bgcolor="#FF6666">

    <h6>We'd like to hear from you</h6>
    </td></tr>

	<tr align="center" ><td align="center"> 
    <h2><a href="suggest.php">Make your Suggestion</a></h2>
    
    </td></tr>
  
   
    </table>
    
    
    

</td>

</tr>


</table>
</td></tr>

</table>

<table width="952" align="center" border="0" background="images/round_back2.png" height="58" >
<tr>
<td></td>
</tr>

</table>

 



<br />






<div id="footer" > 


<table border="0" width="952" height=154 align="center" >
<tr>
<td >
<h1>My Hambaa</h1>
</td>
<td >
<h1>Shopping Policies</h1>
</td>
<td >
<h1>Payment Information</h1>
</td>
<td >
<h1>Contact Us</h1>
</td>
</tr>

<tr>
<td>
<a href = "javascript:void(0)" onclick = "document.getElementById('light').style.display='block';document.getElementById('fade').style.display='block';getShoppingCart()">My Cart</a> |
<a href="myorder.php">My Order</a> |
<a href="about_us.php">FAQs</a>
</td>

<td >
<a href="about_us.php">Return Policy</a> |
<a href="about_us.php">Refund Policy</a> |
<a href="about_us.php">Terms and Conditions</a>
</td>

<td >
<a href="about_us.php">Payment Options: </a>COD
</td>

<td >
e-mail:
<a href="mailto:care@hambaa.com">care@hambaa.com</a>
</td>
</tr>

<tr align="center"><td colspan="4">
<hr />

&copy;2012 All Rights Reserved by <a href="index.php">www.hambaa.com</a>
</td></tr>
</table>
</div>
</body>
</html>
<?php 
ob_end_flush();
?>